Charting on Cross-Tab summaries (Cross-Tab layout)

Seagate Crystal Reports allows you to include a chart based on summary values in your Cross-Tab report. For example, with a Cross-Tab that shows the amount of a certain product sold in each region of the United States, you may want to include a chart showing the percentage of total sales provided by each region for that product.

To create a Cross-Tab chart you must first have a Cross-Tab in your report. For more information, see Cross-Tab Objects.

To chart on a Cross-Tab summary

1. On the Insert menu, click Chart.

   The Chart Expert dialog box appears.

2. On the Type tab, in the Chart type list, click the chart type that best illustrates your data. See Chart types.
3. Click the Data tab.

   

4. In the Layout area, click Cross-Tab.
5. In the Placement area, click Header or Footer to specify where to place your chart.
6. How often your chart appears on the report depends on where the Cross-Tab summary field has been placed.
7. In the Data area, in the On change of list, click the group field you want to base your chart on.
8. If necessary, in the Subdivided by list, click a secondary row or column you want to base your chart on.
9. In the Show list, click the summary field you want to display on your chart.
10. On the Axes and Options tab, add data values, a legend, or other elements to your chart.
11. Click the Text tab.
12. Accept the default title information or add new titles to your chart.
13. Click OK.

    Your chart is placed in the Header or Footer section of the report, depending on your selection in Step 5.

    Note:    When your chart is inserted, it may cover a portion of the report. Move and resize the chart so that it fits properly within the report.